package cn.gson.springboot.model.dao.saledao;

import cn.gson.springboot.model.pjos.Orderdetails;

import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import javax.transaction.Transactional;
import java.util.List;

public interface OrderDetailDao extends CrudRepository<Orderdetails,Integer> {

    //    合并
    @Transactional
    @Modifying
    @Query(nativeQuery = true,value = "select * from orderdetails where orderdetails.order_id=?1")
    public List<Orderdetails> orderDetailInfo(Integer daoId);
}
